<!-- 1903010328 查询通行证 -->
<?php
include "../../inc/log/adsession.php";
?>
<!doctype html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>菜单管理首页</title>
	<link rel="stylesheet" type="text/css" href="/28/inc/CSS/admin">
	<link rel="stylesheet" type="text/css" href="/28/inc/CSS/reset.css">
<?php
	include "../../inc/data/connAdmin.php";

// 预处理sql语句，得到mysqli_stmt对象，绑定参数
$sql = "select menuname,link,remark,tePre,stuPre,score,user from mamx_menu";
$stmt = $conn->prepare($sql);
//执行查询
$stmt->execute();
//绑定结果
$stmt->bind_result($menuName,$Link,$reMark,$tePer,$stuPer,$Score,$User);
//保存结果
$stmt->store_result();
$stmt->fetch();
?>

</head>
<body>
	<div id="tScoreln">
		<!--顶部-->
			<div id="top">
			<img src="/28/inc/pic/00.png">
			<!--导航栏区域和下拉列表-->
			<div id="top-rig">
			<ul>
			    <li><a href="">首页</a></li>
			    <li id="ddown"><a href="" id="dropbtn">学校概况</a>
				    <div id="ddown-content">
				    <a href="">学校简介</a>
				    <a href="">历任教师</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">国际合作</a>
				    <div id="ddown-content">
				    <a href="">交流概况</a>
				    <a href="">国际学生</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">院系部门</a>
				    <div id="ddown-content">
				    <a href="">党群机构</a>
				    <a href="">管理与服务机构</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">科学研究</a>
				    <div id="ddown-content">
				    <a href="">科研概况</a>
				    <a href="">重点学科</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">教师队伍</a>
				    <div id="ddown-content">
				    <a href="">总体介绍</a>
				    <a href="">杰出人才</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">人才培养</a>
				    <div id="ddown-content">
				    <a href="">继续教育</a>
				    <a href="">奖贷学金</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">人才招聘</a>
				    <div id="ddown-content">
				    <a href="">优秀博士后</a>
				    <a href="">应聘方式</a>
				    </div>
				</li>
                <li id="ddown"><a href="" id="dropbtn">招生就业</a>
				    <div id="ddown-content">
				    <a href="">本科生招生</a>
				    <a href="">就业服务</a>
				    </div>
				</li>
				<img src="/28/inc/pic/find1.png">
		    </ul>
			</div>
			</div>
	    <!--顶部结束-->
	    <!---->
	    	<div id="main">
	        	<img src="/28/inc/pic/position.png">
	    		当前位置: 后台首页-菜单管理
	    <!--结束-->
	    <div id="yh">
	    <img src="/28/inc/pic/user.png" style="width:25px;height:25px;margin:3px 10px;">
		<!-- 1903010328 动态信息 -->
		<h4 style="margin:8px 10px;font-size:20px;color:#1D50A2">您好！
		<?=$_SESSION["uName"]?>
		</h4>
	    </div>
	    <div id="SZ" style="">
	    	<ul style="font-size:20px;">
	    	<li id="" style="">
	    		<li id="" style="">
				<a href="../admin.php">后台首页</a></li>
				<li id="" style="">
				<a href="/28/admin/menu/menuAdmin.php">菜单管理</a></li>
				<li id="" style="">
				<a href="/28/admin/dep/depAdmin.php">二级学院管理</a></li>
				<li id="" style="">
				<a href="">教师管理</a></li>
				<li id="" style="">
				<a href="/28/admin/stu/stuAdmin.php">学生管理</a></li>
				<li id="" style="">
				<a href="/28/admin/cou/courseAdmin.php">课程管理</a></li>
				<li id="" style="">
				<a href="28/admin/course/taskAdmin.php">教学任务管理</a></li>
				<li id="" style="">
				<a href="/28/admin/adminQuit.php">注销</a></li>
				<li id="" style="">
				<a href="menuAdd.php"><input type="button" value="添加菜单" name="menu" style="width:100px;height:25px;background-color:#1eca1c;color:white"></a></li>
			</ul>
	    </div>
		<!--结束-->
	    <!--表格区域-->
	<div class="">
		<!-- 统计表 -->
			<table style="width:90%;height:100px;margin:70px auto;text-align:center;border:4px solid #1D50A2">
				<tr style="font-size:25px;color:#43a85e;font-weight:bold">
					<td>序号</td>
      				<td>菜单名</td>
      				<td>超级链接目的地</td>
      				<td>备注</td>
      				<td>教师权限</td>
      				<td>学生权限</td>
				    <td>是否成绩子菜单</td>
				    <td>是否用户设置子菜单</td>
				    <td>操作</td>
				</tr>
				<?php
    				$sql = "select menuname,link,remark,tePre,stuPre,score,user from mamx_menu";
    				$re = $conn->query($sql);
    				$i = 1;
   				    while($row = $re->fetch_assoc()){
    			?>
				<tr style="font-size:20px;">
					<td><?=$i?></td>
      				<td><?=$row['menuname']?></td>
      				<td style="font-weight:bold;color:brown"><?=$row['link']?></td>
			        <td><?=$row['remark']?></td>
			        <td><?=$row['tePre']?></td>
			        <td><?=$row['stuPre']?></td>
			        <td><?=$row['score']?></td>
			        <td><?=$row['user']?></td>
					<td>
					<a href="menuModi.php?menu=<?=$row['menuname']?>" style="color:#f79b28;font-weight:bold">修改</a> /
					<a href="menuDel.php?menu=<?=$row['menuname']?>" style="color:#287bf7;font-weight:bold">删除</a>
					</td>       
				</tr>	
		<?php $i++;} ?>
			</table>
		</div>
	</div>
</body>
</html>